USE NGroup_VTL_DB
GO

ALTER TABLE [NGroup_VTL_DB].[dbo].[News]
ADD 
[Title_En]				[nvarchar](500) NOT NULL DEFAULT(''),
[MetaContent_En]		[nvarchar](1500) NULL,
[BriefContent_En]		[nvarchar](4000) NULL,
[FullContent_En]		[nvarchar](max) NOT NULL DEFAULT(''),
[ImageSmallURL_En]		[nvarchar](500) NULL
GO

UPDATE [NGroup_VTL_DB].[dbo].[News]
   SET [Title_En] = [Title] + ' (English)'
      ,[MetaContent_En] = [MetaContent]
      ,[BriefContent_En] = [BriefContent]
      ,[FullContent_En] = [FullContent]
      ,[ImageSmallURL_En] = [ImageSmallURL]
 WHERE 1 = 1